How do I convert this to Snowflake SQL

join shbcf.ru